﻿CREATE TABLE [dbo].[Passengers] (
    [PassengerId]        INT          IDENTITY (1, 1) NOT NULL,
    [FirstName]          VARCHAR (20) NOT NULL,
    [LastName]           VARCHAR (20) NOT NULL,
    [TitleCode]          VARCHAR (10) NOT NULL,
    [DateOfBirth]        DATE         NOT NULL,
    [PassportNo]         VARCHAR (20) NOT NULL,
    [PassportExpiryDate] DATE         NOT NULL,
    [EmailAddress]       VARCHAR (30) NULL,
    [ContactNo]          VARCHAR (10) NULL
);

